package mdb.com.vn.model;

import java.io.Serializable;

import javax.persistence.*;

import java.math.BigDecimal;
import java.util.Date;


/**
 * The persistent class for the IFTB_LOANS_SMS database table.
 * 
 */
@Entity
@Table(name="IFTB_LOANS_SMS")
@NamedQueries({
	@NamedQuery(name="LoansSMS.findByStatus", query="SELECT l FROM LoansSMS l WHERE l.status = :status"),
	@NamedQuery(name="LoansSMS.findByStatusDate", query="SELECT l FROM LoansSMS l WHERE l.processDate = :processDate AND l.status = :status"),
	@NamedQuery(name="LoansSMS.findByLD", query="SELECT l FROM LoansSMS l WHERE l.refNo = :refNo")
})
public class LoansSMS implements Serializable {
	private static final long serialVersionUID = 1L;

	@Column(name="BRANCH_NAME")
	private String branchName;
	
	@Column(name="BRANCH_CODE")
	private String branchCode;

	@Column(name="CUSTOMER_ID")
	private String customerId;

	@Column(name="CUSTOMER_NAME")
	private String customerName;

	@Column(name="DEALER")
	private String dealer;

	@Column(name="INTEREST_RATE")
	private double interestRate;

	@Column(name="LKD_DETAIL")
	private String lkdDetail;

	@Column(name="LKD_NUM")
	private int lkdNum;

	@Column(name="PHONE_NUMBER")
	private String phoneNumber;

	@Column(name="PR_AMOUNT")
	private BigDecimal prAmount;

	@Temporal(TemporalType.DATE)
	@Column(name="PROCESS_DATE")
	private Date processDate;

	@Column(name="PRODUCT_CODE")
	private String productCode;
	
	@Column(name="CREATED_BY")
	private String createdBy;

	@Temporal(TemporalType.DATE)
	@Column(name="CREATED_DATE")
	private Date createdDate;
	
	@Column(name="UPDATED_BY")
	private String updatedBy;

	@Temporal(TemporalType.DATE)
	@Column(name="UPDATED_DATE")
	private Date updatedDate;

	@Id
	@Column(name="REF_NO")
	private String refNo;

	@Column(name="STATUS")
	private String status;

	@Column(name="TERM")
	private String term;

	@Temporal(TemporalType.DATE)
	@Column(name="VALUE_DATE")
	private Date valueDate;

	@Column(name="CUSTOMER_TYPE")
	private int customerType;
	
	public LoansSMS() {
	}

	/**
	 * @return the branchName
	 */
	public String getBranchName() {
		return branchName;
	}

	/**
	 * @param branchName the branchName to set
	 */
	public void setBranchName(String branchName) {
		this.branchName = branchName;
	}

	/**
	 * @return the customerId
	 */
	public String getCustomerId() {
		return customerId;
	}

	/**
	 * @param customerId the customerId to set
	 */
	public void setCustomerId(String customerId) {
		this.customerId = customerId;
	}

	/**
	 * @return the customerName
	 */
	public String getCustomerName() {
		return customerName;
	}

	/**
	 * @param customerName the customerName to set
	 */
	public void setCustomerName(String customerName) {
		this.customerName = customerName;
	}

	/**
	 * @return the dealer
	 */
	public String getDealer() {
		return dealer;
	}

	/**
	 * @param dealer the dealer to set
	 */
	public void setDealer(String dealer) {
		this.dealer = dealer;
	}

	/**
	 * @return the interestRate
	 */
	public double getInterestRate() {
		return interestRate;
	}

	/**
	 * @param interestRate the interestRate to set
	 */
	public void setInterestRate(double interestRate) {
		this.interestRate = interestRate;
	}

	/**
	 * @return the lkdDetail
	 */
	public String getLkdDetail() {
		return lkdDetail;
	}

	/**
	 * @param lkdDetail the lkdDetail to set
	 */
	public void setLkdDetail(String lkdDetail) {
		this.lkdDetail = lkdDetail;
	}

	/**
	 * @return the lkdNum
	 */
	public int getLkdNum() {
		return lkdNum;
	}

	/**
	 * @param lkdNum the lkdNum to set
	 */
	public void setLkdNum(int lkdNum) {
		this.lkdNum = lkdNum;
	}

	/**
	 * @return the phoneNumber
	 */
	public String getPhoneNumber() {
		return phoneNumber;
	}

	/**
	 * @param phoneNumber the phoneNumber to set
	 */
	public void setPhoneNumber(String phoneNumber) {
		this.phoneNumber = phoneNumber;
	}

	/**
	 * @return the prAmount
	 */
	public BigDecimal getPrAmount() {
		return prAmount;
	}

	/**
	 * @param prAmount the prAmount to set
	 */
	public void setPrAmount(BigDecimal prAmount) {
		this.prAmount = prAmount;
	}

	/**
	 * @return the processDate
	 */
	public Date getProcessDate() {
		return processDate;
	}

	/**
	 * @param processDate the processDate to set
	 */
	public void setProcessDate(Date processDate) {
		this.processDate = processDate;
	}

	/**
	 * @return the productCode
	 */
	public String getProductCode() {
		return productCode;
	}

	/**
	 * @param productCode the productCode to set
	 */
	public void setProductCode(String productCode) {
		this.productCode = productCode;
	}

	/**
	 * @return the refNo
	 */
	public String getRefNo() {
		return refNo;
	}

	/**
	 * @param refNo the refNo to set
	 */
	public void setRefNo(String refNo) {
		this.refNo = refNo;
	}

	/**
	 * @return the status
	 */
	public String getStatus() {
		return status;
	}

	/**
	 * @param status the status to set
	 */
	public void setStatus(String status) {
		this.status = status;
	}

	/**
	 * @return the term
	 */
	public String getTerm() {
		return term;
	}

	/**
	 * @param term the term to set
	 */
	public void setTerm(String term) {
		this.term = term;
	}

	/**
	 * @return the valueDate
	 */
	public Date getValueDate() {
		return valueDate;
	}

	/**
	 * @param valueDate the valueDate to set
	 */
	public void setValueDate(Date valueDate) {
		this.valueDate = valueDate;
	}

	/**
	 * @return the customerType
	 */
	public int getCustomerType() {
		return customerType;
	}

	/**
	 * @param customerType the customerType to set
	 */
	public void setCustomerType(int customerType) {
		this.customerType = customerType;
	}

	/**
	 * @return the createdBy
	 */
	public String getCreatedBy() {
		return createdBy;
	}

	/**
	 * @param createdBy the createdBy to set
	 */
	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	/**
	 * @return the createdDate
	 */
	public Date getCreatedDate() {
		return createdDate;
	}

	/**
	 * @param createdDate the createdDate to set
	 */
	public void setCreatedDate(Date createdDate) {
		this.createdDate = createdDate;
	}

	/**
	 * @return the updatedBy
	 */
	public String getUpdatedBy() {
		return updatedBy;
	}

	/**
	 * @param updatedBy the updatedBy to set
	 */
	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	/**
	 * @return the updatedDate
	 */
	public Date getUpdatedDate() {
		return updatedDate;
	}

	/**
	 * @param updatedDate the updatedDate to set
	 */
	public void setUpdatedDate(Date updatedDate) {
		this.updatedDate = updatedDate;
	}

	/**
	 * @return the branchCode
	 */
	public String getBranchCode() {
		return branchCode;
	}

	/**
	 * @param branchCode the branchCode to set
	 */
	public void setBranchCode(String branchCode) {
		this.branchCode = branchCode;
	}


}